[SQL] How to select a newest record for each group Turn Back
2018-09-14 14:47:45
SELECT t.SubcateCode, t.NewsID, t.PrintDate, t.Story, t.Headlinefrom IRNews tINNER JOIN (SELECT NewsID,SubcateCode, MAX(PrintDate) as MaxDateFROM IRNewsWHERE CategoryCode='EVN'GROUP BY SubcateCode) tm ON t.SubcateCode = tm.SubcateCode AND t.PrintDate = tm.MaxDate